package com.dhu.demo.mapper;

import com.dhu.demo.entity.Sc;
import com.dhu.demo.entity.ScKey;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface ScMapper {
    List<Sc> findAll();

    int deleteByPrimaryKey(ScKey key);

    int deleteAllInfoByStudentnumber(int studentnumber);
    String deleteAllInfoByClassName(String classname);

    int insert(Sc record);

    int insertSelective(Sc record);

    Sc selectByPrimaryKey(ScKey key);

    int updateByPrimaryKeySelective(Sc record);

    int updateByPrimaryKey(Sc record);

    List<Sc> selectAllScoreByStudentnumberAndXueqi(int studentnumber,String xueqi);

    List<Sc> selectAllInfoByClassName(String classname);
    List<Sc> selectAllInfoByScore(int score);
}